﻿CREATE TABLE [dbo].[Promociones] (
    [IdPromocion]     INT           IDENTITY (1, 1) NOT NULL,
    [IdTipoFormaPago] TINYINT       NOT NULL,
    [Nombre]          VARCHAR (50)  NOT NULL,
    [FechaDesde]      DATE          NOT NULL,
    [FechaHasta]      DATE          NOT NULL,
    [Lunes]           BIT           NOT NULL,
    [Martes]          BIT           NOT NULL,
    [Miercoles]       BIT           NOT NULL,
    [Jueves]          BIT           NOT NULL,
    [Viernes]         BIT           NOT NULL,
    [Sabado]          BIT           NOT NULL,
    [Domingo]         BIT           NOT NULL,
    [Observacion]     VARCHAR (500) NOT NULL,
    [Cantidad]        INT           NOT NULL,
    [HoraDesde]       TIME (0)      NOT NULL,
    [HoraHasta]       TIME (0)      NOT NULL,
    [Descuento]       MONEY         NOT NULL
);



